18. DWH Architecture: Kimball's Bus Architecture

L01-05-Part 1 Architecture- Kimballs

Identify the main characteristics of the Kimball Bus Architecture:

SOLUTION:
  • Results in a common dimension data model shared by different departments
  • Data is not kept at the aggregated level, but rather at the atomic level
  • Organized by business processes, and used by different departments

In the Kimball architecture, the sales analytics and the delivery analytics will both use the same data dimension

SOLUTION: True